/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50718
 Source Host           : localhost
 Source Database       : test

 Target Server Version : 50718
 File Encoding         : utf-8

 Date: 11/25/2017 23:31:05 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `test_demo_user`
-- ----------------------------
DROP TABLE IF EXISTS `test_demo_user`;
CREATE TABLE `test_demo_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
  `job_num` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '工号',
  `user_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '登录账号',
  `password` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '账户类型:1内部账户，2外部注册',
  `depid` int(30) DEFAULT NULL COMMENT '所在部门，可空',
  `dep_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '部門名稱',
  `comid` int(30) DEFAULT NULL,
  `qq` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'qq账号',
  `com_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司名稱',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '1' COMMENT '在职状态：1在职，0离职，3删除',
  `phone` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_at` timestamp NULL DEFAULT NULL,
  `update_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `gender` int(1) DEFAULT '0' COMMENT '性别：0女，1男',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户';

-- ----------------------------
--  Records of `test_demo_user`
-- ----------------------------
BEGIN;
INSERT INTO `test_demo_user` VALUES ('1', '超级管理员', null, 'admin', 'e10adc3949ba59abbe56e057f20f883e', null, null, null, null, '', null, '1', 'admin', '2017-03-14 15:09:22', '2017-11-24 11:13:01', null), ('21', '王文庆', '00100001', '8813', 'a29f962d06f78c64d572f5112e641558', null, '6', '平台运营部', '1', '', '上海海鹏化工科技有限公司', '1', '18721787382', '2017-04-11 05:17:46', '2017-08-31 09:46:09', '1'), ('22', '郝灵童', '00100002', '8836', 'e10adc3949ba59abbe56e057f20f883e', null, '9', '异丙醇运营部', '1', '993899299', '上海海鹏化工科技有限公司', '3', '18321873530', '2017-04-11 05:28:41', '2017-08-03 11:04:08', '1'), ('23', '周娜', '00100003', '8839', '72b4003043b415d41ef34a4ad1df5220', null, '6', '平台运营部', '1', '3127799120', '上海海鹏化工科技有限公司', '1', '18916203315', '2017-04-17 05:02:17', '2017-07-29 13:37:45', '0'), ('24', '王利英', '00100004', '8810', '52cb2b72cd0956455afa8d931161f043', null, '9', '异丙醇运营部', '1', '634822038', '上海海鹏化工科技有限公司', '1', '13817384666', '2017-04-17 07:40:20', '2017-07-29 13:37:04', '1'), ('25', '周浪青', '00100005', '8803', '48362ade17cd04b0d84467a405bf673a', null, '10', '物流运营部', '1', '', '上海海鹏化工科技有限公司', '1', '', '2017-04-18 05:51:42', '2017-09-12 12:12:53', '0'), ('26', '刘春燕', '00100006', '8811', '55073f80c4e2b6be39a7ee221e8b733a', null, '12', '乙二醇运营部', '1', '2545078302', '上海海鹏化工科技有限公司', '1', '13661794937', '2017-04-20 08:57:56', '2017-07-29 13:38:24', '0'), ('27', '陈杰', '00100007', '8824', '2580ef0e5bab29d76d9418dc36f52c61', null, '11', '二甘醇运营部', '1', '2653151275', '上海海鹏化工科技有限公司', '1', '13262592529', '2017-04-20 08:59:04', '2017-07-29 13:39:55', '1'), ('28', '艾雪', '00100008', '8812', 'e10adc3949ba59abbe56e057f20f883e', null, '12', '乙二醇运营部', '1', '3127799120', '上海海鹏化工科技有限公司', '0', '13917531840', '2017-04-20 09:00:14', '2017-05-16 05:34:12', '0'), ('29', '柯亚云', '00100009', '8831', '709234303f81a9ecfc9e41b0a7ec89cc', null, '11', '二甘醇运营部', '1', '494408809', '上海海鹏化工科技有限公司', '1', '13916990966', '2017-04-20 09:01:08', '2017-07-29 18:19:46', '0'), ('30', '陈雅楠', '00100010', '8842', '001793d1e48ece880b94c445c6bbae30', null, '6', '平台运营部', '1', '', '上海海鹏化工科技有限公司', '1', '18949775025', '2017-04-26 06:24:48', '2017-08-02 11:15:46', '0'), ('31', '肖玲', '00100011', '8822', '70636ae2bcf6aa5861913f230e3bf296', null, '13', '甲醇运营部', '1', '2807606681', '上海海鹏化工科技有限公司', '1', '18221589269', '2017-05-02 09:51:44', '2017-05-06 06:41:35', '0'), ('32', '朱海燕', '00100012', '8833', '1ddcb3b84a2b5df25c30e437c7d45c27', null, '13', '甲醇运营部', '1', '1940688691', '上海海鹏化工科技有限公司', '1', '13601678394', '2017-05-02 09:53:02', '2017-05-03 08:39:08', '0'), ('33', '董珍', '00100013', '8821', 'e10adc3949ba59abbe56e057f20f883e', null, '14', '苯乙烯运营部', '1', '1743999026', '上海海鹏化工科技有限公司', '1', '13917388450', '2017-05-02 09:54:24', '2017-05-02 09:54:24', '0'), ('34', '成汝青', '00100014', '8840', '1b0c82c6f10e78b613dcb12c7b53edc2', null, '7', '苯乙烯运营部', '1', '381354322', '上海海鹏化工科技有限公司', '1', '13788945958', '2017-05-02 09:55:14', '2017-11-21 09:24:28', '0'), ('35', '王小平', '00100015', '8817', 'e10adc3949ba59abbe56e057f20f883e', null, '6', '平台运营部', '1', '', '上海海鹏化工科技有限公司', '0', '18019715991', '2017-05-11 01:15:31', '2017-08-16 11:28:27', '0'), ('36', '陈丽君', '00100016', '8837', 'e10adc3949ba59abbe56e057f20f883e', null, '6', '平台运营部', '1', '', '上海海鹏化工科技有限公司', '1', '18482169831', '2017-05-11 09:35:49', '2017-05-11 09:35:49', '0'), ('37', '郭晓珺', '00100017', '8802', 'e10adc3949ba59abbe56e057f20f883e', null, '10', '物流运营部', '1', '', '上海海鹏化工科技有限公司', '1', '60564021', '2017-05-25 05:42:18', '2017-07-24 16:18:31', '0'), ('38', '范晓慧', '00100018', '8801', 'e10adc3949ba59abbe56e057f20f883e', null, '10', '物流运营部', '1', '', '上海海鹏化工科技有限公司', '1', '60564009', '2017-05-25 05:45:08', '2017-07-24 16:39:56', '0'), ('50', '陶云', '00100019', '8828', '72da43b6f18c8c03b59f387e6bece8b3', null, '7', null, '1', '1559078306', null, '1', '13564996082', '2017-07-24 15:14:20', '2017-07-29 13:47:39', '0'), ('54', '周宣', '00100020', '8843', '617ccf97bbd6c6e6bc5730024d9f4894', null, '8', null, '1', '2892851776', null, '1', '13818829179', '2017-07-24 15:17:36', '2017-09-30 10:58:22', '0'), ('55', 'ccccc', '00100021', 'admin1', 'e10adc3949ba59abbe56e057f20f883e', null, '12', null, '1', '1341470626', null, '3', '15029351330', '2017-07-24 17:49:34', '2017-07-29 12:19:52', '1'), ('56', 'ccccc', '00100022', 'admin1', 'e10adc3949ba59abbe56e057f20f883e', null, '12', null, '1', '1341470626', null, '3', '15029351330', '2017-07-24 17:49:34', '2017-07-29 12:20:10', '1'), ('57', 'ccccc', '00100022', 'admin1', 'e10adc3949ba59abbe56e057f20f883e', null, '12', null, '1', '1341470626', null, '3', '15029351330', '2017-07-24 17:49:34', '2017-07-29 12:20:06', '1'), ('58', 'ccccc', '00100021', 'admin1', 'e10adc3949ba59abbe56e057f20f883e', null, '12', null, '1', '1341470626', null, '3', '15029351330', '2017-07-24 17:49:34', '2017-07-29 12:20:18', '1'), ('59', '施群丽', '00100025', '88451', 'c8837b23ff8aaa8a2dde915473ce0991', null, '14', null, '1', '1061818344', null, '0', '13918139189', '2017-07-27 11:32:57', '2017-09-25 10:39:23', '0'), ('60', '杨兴旺', '00100026', '8844', '6cbaf68fdb6a0a53b58b6d6f921caf1f', null, '8', null, '1', '3526153346', null, '1', '15721561475', '2017-07-28 14:07:49', '2017-08-04 09:22:50', '1'), ('61', '李英玉', '00100027', '8818', '962ee999d7fde1448c4269e866ec796a', null, '14', null, '1', '', null, '1', '15221545988', '2017-07-28 14:15:39', '2017-08-14 17:13:46', '0'), ('62', '曹伟萍', '00100028', '8816', 'e10adc3949ba59abbe56e057f20f883e', null, '6', null, '1', '', null, '1', '18621038816', '2017-07-28 14:21:10', '2017-08-02 14:54:01', '0'), ('63', '祝瑞娟', '00100029', '8834', '73c18bf825aa5ca4930a267082f5f337', null, '6', null, '1', '', null, '1', '18117101653', '2017-07-28 14:23:18', '2017-08-15 09:00:27', '0'), ('64', '张萍', '00100030', '8841', 'e10adc3949ba59abbe56e057f20f883e', null, '9', null, '1', '993899299', null, '1', '18930532981', '2017-07-29 13:48:38', '2017-07-29 13:48:38', '0'), ('65', '周浪青', '00100031', '8803-1', 'e10adc3949ba59abbe56e057f20f883e', null, '10', null, '1', '', null, '3', '15000840731', '2017-08-02 16:29:15', '2017-08-03 11:03:25', '0'), ('67', '周浪青电', '00100033', '88031', 'c8837b23ff8aaa8a2dde915473ce0991', null, '10', null, '1', '', null, '1', '15000840731', '2017-08-03 12:19:14', '2017-09-12 11:46:53', '0'), ('68', '范晓慧电', '00100033', '88011', 'a906449d5769fa7361d7ecc6aa3f6d28', null, '10', null, '1', '', null, '1', '18516756051', '2017-08-09 16:48:35', '2017-08-09 17:13:17', '0'), ('69', '郭晓珺电', '00100034', '88021', 'a906449d5769fa7361d7ecc6aa3f6d28', null, '10', null, '1', '', null, '1', '15821204826', '2017-08-09 17:10:37', '2017-08-09 17:13:38', '0'), ('70', 'miss chen', '00100035', '88421', 'e10adc3949ba59abbe56e057f20f883e', null, '14', null, '1', '2020633829', null, '1', '13296070639', '2017-08-10 16:14:55', '2017-08-10 16:21:36', '0'), ('71', '徐奥燃', '00100036', '8838', 'f367ee1027d5b06952cf63032e126be6', null, '16', null, '1', '', null, '1', '18918297125', '2017-08-21 14:20:27', '2017-08-21 14:48:57', '0'), ('72', '88411', '00100037', '张女士', 'e10adc3949ba59abbe56e057f20f883e', null, '16', null, '1', '993899299', null, '3', '18930532982', '2017-09-04 18:14:32', '2017-09-04 18:15:52', '0'), ('73', '张女士', '00100038', '88411', 'e10adc3949ba59abbe56e057f20f883e', null, '9', null, '1', '993899299', null, '1', '18930532982', '2017-09-04 18:16:42', '2017-09-04 18:16:42', '0'), ('74', '杨先生', '00100039', '88441', 'e10adc3949ba59abbe56e057f20f883e', null, '8', null, '1', '3526153346', null, '1', '15721561476', '2017-09-04 18:19:40', '2017-09-04 18:20:49', '1'), ('75', '周女士', '00100040', '88431', 'e10adc3949ba59abbe56e057f20f883e', null, '8', null, '1', '2892851776', null, '1', '13818829178', '2017-09-04 18:20:43', '2017-09-04 18:20:43', '0'), ('76', '陶女士', '00100041', '88281', 'e10adc3949ba59abbe56e057f20f883e', null, '7', null, '1', '1559078306', null, '1', '13564996083', '2017-09-04 18:21:45', '2017-09-04 18:21:45', '0'), ('77', '成女士', '00100042', '88401', 'e10adc3949ba59abbe56e057f20f883e', null, '14', null, '1', '381354322', null, '1', '13788945959', '2017-09-04 18:22:39', '2017-09-04 18:22:39', '0'), ('78', '董女士', '00100043', '88211', 'e10adc3949ba59abbe56e057f20f883e', null, '14', null, '1', '1743999026', null, '1', '13917388451', '2017-09-04 18:23:26', '2017-09-04 18:23:26', '0'), ('79', '朱女士', '00100044', '88331', 'e10adc3949ba59abbe56e057f20f883e', null, '13', null, '1', '1940688691', null, '1', '13601678395', '2017-09-04 18:24:11', '2017-09-04 18:24:11', '0'), ('80', '肖女士', '00100045', '88221', 'e10adc3949ba59abbe56e057f20f883e', null, '13', null, '1', '2807606681', null, '1', '18221589268', '2017-09-04 18:24:54', '2017-09-04 18:24:54', '0'), ('81', '柯女士', '00100046', '88311', 'e10adc3949ba59abbe56e057f20f883e', null, '11', null, '1', '494408809', null, '1', '13916990967', '2017-09-04 18:25:35', '2017-09-04 18:25:35', '0'), ('82', '陈先生', '00100047', '88241', 'e10adc3949ba59abbe56e057f20f883e', null, '11', null, '1', '2653151275', null, '1', '13262592528', '2017-09-04 18:26:27', '2017-09-04 18:26:27', '1'), ('83', '刘女士', '00100048', '88111', 'e10adc3949ba59abbe56e057f20f883e', null, '12', null, '1', '2545078302', null, '1', '13661794938', '2017-09-04 18:27:12', '2017-09-04 18:27:12', '0'), ('84', '王先生', '00100049', '88101', 'e10adc3949ba59abbe56e057f20f883e', null, '9', null, '1', '634822038', null, '1', '13817384667', '2017-09-04 18:28:07', '2017-09-04 18:28:07', '1'), ('85', '周女士', '00100050', '88391', 'e10adc3949ba59abbe56e057f20f883e', null, '6', null, '1', '3127799120', null, '1', '18916203316', '2017-09-04 18:28:51', '2017-09-04 18:28:51', '0'), ('86', '占静玲', '00100051', '8847', 'e10adc3949ba59abbe56e057f20f883e', null, '16', null, '1', '+2455975674', null, '1', '13918174058', '2017-09-25 10:31:09', '2017-09-25 10:31:09', '0'), ('87', '邹晓丽', '00100052', '8846', 'eab73e40a8c1a51907858a57c0b000ed', null, '16', null, '1', '2876684311', null, '0', '13917757459', '2017-09-25 10:31:45', '2017-10-26 17:50:41', '0'), ('88', '郑玉然', '00100053', '8845', 'c5fdcd2cd99116e097e63b5faba6126c', null, '16', null, '1', '2848006953', null, '0', '18018521657', '2017-09-25 10:40:01', '2017-10-26 17:50:34', '1'), ('89', '奚海涛', '00100054', '8848', 'e10adc3949ba59abbe56e057f20f883e', null, '16', null, '1', '3210172122', null, '0', '18621319880', '2017-10-11 13:43:08', '2017-10-26 17:50:23', '1'), ('90', 'GZ', '00100055', '8888', 'f7d82a97cb8ee7e1937c0334a990d69a', null, '16', null, '1', '', null, '1', '13988888888', '2017-10-30 20:34:45', '2017-11-03 09:23:54', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
